Overview
Brought to you by YData
Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 16.978.680 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 171.936 |
| Duplicate rows (%) | 1.0% |
| Total size in memory | 5.4 GiB |
| Average record size in memory | 343.9 B |
Variable types
| Numeric | 7 |
|---|---|
| Categorical | 5 |
| Text | 1 |
| Dataset has 171936 (1.0%) duplicate rows | Duplicates |
brand is highly overall correlated with cat1 and 1 other fields | High correlation |
cat1 is highly overall correlated with brand and 1 other fields | High correlation |
cat2 is highly overall correlated with brand and 1 other fields | High correlation |
cust_request_qty is highly overall correlated with cust_request_tn and 1 other fields | High correlation |
cust_request_tn is highly overall correlated with cust_request_qty and 1 other fields | High correlation |
product_id is highly overall correlated with sku_size | High correlation |
sku_size is highly overall correlated with product_id | High correlation |
tn is highly overall correlated with cust_request_qty and 1 other fields | High correlation |
plan_precios_cuidados is highly imbalanced (98.2%) | Imbalance |
cust_request_tn is highly skewed (γ1 = 95.58229409) | Skewed |
tn is highly skewed (γ1 = 96.08283194) | Skewed |
periodo is uniformly distributed | Uniform |
cust_request_qty has 14646469 (86.3%) zeros | Zeros |
cust_request_tn has 14646469 (86.3%) zeros | Zeros |
tn has 14646469 (86.3%) zeros | Zeros |
stock_final has 10719135 (63.1%) zeros | Zeros |
Reproduction
| Analysis started | 2025-06-03 23:20:12.938511 |
|---|---|
| Analysis finished | 2025-06-03 23:34:36.897129 |
| Duration | 14 minutes and 23.96 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
customer_id
Real number (ℝ)
| Distinct | 597 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10303.682 |
| Minimum | 10001 |
|---|---|
| Maximum | 10637 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 129.5 MiB |
Quantile statistics
| Minimum | 10001 |
|---|---|
| 5-th percentile | 10030 |
| Q1 | 10150 |
| median | 10299 |
| Q3 | 10455 |
| 95-th percentile | 10590 |
| Maximum | 10637 |
| Range | 636 |
| Interquartile range (IQR) | 305 |
Descriptive statistics
| Standard deviation | 178.7095 |
|---|---|
| Coefficient of variation (CV) | 0.017344237 |
| Kurtosis | -1.1520989 |
| Mean | 10303.682 |
| Median Absolute Deviation (MAD) | 153 |
| Skewness | 0.073405409 |
| Sum | 1.7494292 × 1011 |
| Variance | 31937.087 |
| Monotonicity | Increasing |
| Value | Count | Frequency (%) |
| 10001 | 28440 | 0.2% |
| 10395 | 28440 | 0.2% |
| 10398 | 28440 | 0.2% |
| 10399 | 28440 | 0.2% |
| 10400 | 28440 | 0.2% |
| 10402 | 28440 | 0.2% |
| 10404 | 28440 | 0.2% |
| 10405 | 28440 | 0.2% |
| 10406 | 28440 | 0.2% |
| 10407 | 28440 | 0.2% |
| Other values (587) | 16694280 |
| Value | Count | Frequency (%) |
| 10001 | 28440 | |
| 10002 | 28440 | |
| 10003 | 28440 | |
| 10004 | 28440 | |
| 10005 | 28440 | |
| 10006 | 28440 | |
| 10007 | 28440 | |
| 10008 | 28440 | |
| 10009 | 28440 | |
| 10010 | 28440 |
| Value | Count | Frequency (%) |
| 10637 | 28440 | |
| 10636 | 28440 | |
| 10635 | 28440 | |
| 10634 | 28440 | |
| 10633 | 28440 | |
| 10632 | 28440 | |
| 10631 | 28440 | |
| 10630 | 28440 | |
| 10629 | 28440 | |
| 10626 | 28440 |
product_id
Real number (ℝ)
High correlation 
| Distinct | 780 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20536.509 |
| Minimum | 20001 |
|---|---|
| Maximum | 21276 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 129.5 MiB |
Quantile statistics
| Minimum | 20001 |
|---|---|
| 5-th percentile | 20037 |
| Q1 | 20233 |
| median | 20504 |
| Q3 | 20815 |
| 95-th percentile | 21167 |
| Maximum | 21276 |
| Range | 1275 |
| Interquartile range (IQR) | 582 |
Descriptive statistics
| Standard deviation | 354.77362 |
|---|---|
| Coefficient of variation (CV) | 0.017275264 |
| Kurtosis | -1.0199484 |
| Mean | 20536.509 |
| Median Absolute Deviation (MAD) | 285 |
| Skewness | 0.30801862 |
| Sum | 3.4868281 × 1011 |
| Variance | 125864.32 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 20278 | 42984 | 0.3% |
| 20192 | 42984 | 0.3% |
| 20020 | 42984 | 0.3% |
| 20021 | 42984 | 0.3% |
| 20022 | 42984 | 0.3% |
| 20010 | 42984 | 0.3% |
| 20100 | 42984 | 0.3% |
| 20230 | 42984 | 0.3% |
| 20623 | 42984 | 0.3% |
| 20037 | 42984 | 0.3% |
| Other values (770) | 16548840 |
| Value | Count | Frequency (%) |
| 20001 | 21492 | |
| 20002 | 21492 | |
| 20003 | 21492 | |
| 20004 | 21492 | |
| 20005 | 21492 | |
| 20006 | 21492 | |
| 20007 | 21492 | |
| 20008 | 21492 | |
| 20009 | 21492 | |
| 20010 | 42984 |
| Value | Count | Frequency (%) |
| 21276 | 21492 | |
| 21267 | 21492 | |
| 21266 | 21492 | |
| 21265 | 21492 | |
| 21263 | 21492 | |
| 21262 | 21492 | |
| 21259 | 21492 | |
| 21256 | 21492 | |
| 21252 | 21492 | |
| 21248 | 21492 |
periodo
Categorical
Uniform 
| Distinct | 36 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 955.3 MiB |
| 2017-01-01 | 471630 |
|---|---|
| 2017-02-01 | 471630 |
| 2017-09-01 | 471630 |
| 2017-03-01 | 471630 |
| 2017-04-01 | 471630 |
| Other values (31) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2017-01-01 |
|---|---|
| 2nd row | 2017-02-01 |
| 3rd row | 2017-03-01 |
| 4th row | 2017-04-01 |
| 5th row | 2017-05-01 |
Common Values
| Value | Count | Frequency (%) |
| 2017-01-01 | 471630 | 2.8% |
| 2017-02-01 | 471630 | 2.8% |
| 2017-09-01 | 471630 | 2.8% |
| 2017-03-01 | 471630 | 2.8% |
| 2017-04-01 | 471630 | 2.8% |
| 2017-05-01 | 471630 | 2.8% |
| 2017-06-01 | 471630 | 2.8% |
| 2017-07-01 | 471630 | 2.8% |
| 2017-08-01 | 471630 | 2.8% |
| 2017-10-01 | 471630 | 2.8% |
| Other values (26) | 12262380 |
Length
| Value | Count | Frequency (%) |
| 2017-01-01 | 471630 | 2.8% |
| 2017-02-01 | 471630 | 2.8% |
| 2019-03-01 | 471630 | 2.8% |
| 2018-09-01 | 471630 | 2.8% |
| 2018-10-01 | 471630 | 2.8% |
| 2018-11-01 | 471630 | 2.8% |
| 2018-12-01 | 471630 | 2.8% |
| 2019-01-01 | 471630 | 2.8% |
| 2019-02-01 | 471630 | 2.8% |
| 2019-04-01 | 471630 | 2.8% |
| Other values (26) | 12262380 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 48106260 | |
| 1 | 41031810 | |
| - | 33957360 | |
| 2 | 19808460 | |
| 7 | 7074450 | 4.2% |
| 9 | 7074450 | 4.2% |
| 8 | 7074450 | 4.2% |
| 3 | 1414890 | 0.8% |
| 4 | 1414890 | 0.8% |
| 5 | 1414890 | 0.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 135829440 | |
| Dash Punctuation | 33957360 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 48106260 | |
| 1 | 41031810 | |
| 2 | 19808460 | |
| 7 | 7074450 | 5.2% |
| 9 | 7074450 | 5.2% |
| 8 | 7074450 | 5.2% |
| 3 | 1414890 | 1.0% |
| 4 | 1414890 | 1.0% |
| 5 | 1414890 | 1.0% |
| 6 | 1414890 | 1.0% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 33957360 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 169786800 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 48106260 | |
| 1 | 41031810 | |
| - | 33957360 | |
| 2 | 19808460 | |
| 7 | 7074450 | 4.2% |
| 9 | 7074450 | 4.2% |
| 8 | 7074450 | 4.2% |
| 3 | 1414890 | 0.8% |
| 4 | 1414890 | 0.8% |
| 5 | 1414890 | 0.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 169786800 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 48106260 | |
| 1 | 41031810 | |
| - | 33957360 | |
| 2 | 19808460 | |
| 7 | 7074450 | 4.2% |
| 9 | 7074450 | 4.2% |
| 8 | 7074450 | 4.2% |
| 3 | 1414890 | 0.8% |
| 4 | 1414890 | 0.8% |
| 5 | 1414890 | 0.8% |
plan_precios_cuidados
Categorical
Imbalance 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 842.0 MiB |
| 0.0 | |
|---|---|
| 1.0 | 27930 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 16950750 | |
| 1.0 | 27930 | 0.2% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 16950750 | |
| 1.0 | 27930 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 33929430 | |
| . | 16978680 | |
| 1 | 27930 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 33957360 | |
| Other Punctuation | 16978680 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 33929430 | |
| 1 | 27930 | 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 16978680 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 50936040 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 33929430 | |
| . | 16978680 | |
| 1 | 27930 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 50936040 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 33929430 | |
| . | 16978680 | |
| 1 | 27930 | 0.1% |
cust_request_qty
Real number (ℝ)
High correlation  Zeros 
| Distinct | 85 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.29828544 |
| Minimum | 0 |
|---|---|
| Maximum | 92 |
| Zeros | 14646469 |
| Zeros (%) | 86.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 129.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 92 |
| Range | 92 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.5508814 |
|---|---|
| Coefficient of variation (CV) | 5.1993198 |
| Kurtosis | 302.13614 |
| Mean | 0.29828544 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 14.486984 |
| Sum | 5064493 |
| Variance | 2.4052331 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 14646469 | |
| 1 | 1607873 | 9.5% |
| 2 | 355885 | 2.1% |
| 3 | 119199 | 0.7% |
| 4 | 64614 | 0.4% |
| 5 | 36682 | 0.2% |
| 6 | 24818 | 0.1% |
| 7 | 18335 | 0.1% |
| 8 | 14547 | 0.1% |
| 9 | 11091 | 0.1% |
| Other values (75) | 79167 | 0.5% |
| Value | Count | Frequency (%) |
| 0 | 14646469 | |
| 1 | 1607873 | 9.5% |
| 2 | 355885 | 2.1% |
| 3 | 119199 | 0.7% |
| 4 | 64614 | 0.4% |
| 5 | 36682 | 0.2% |
| 6 | 24818 | 0.1% |
| 7 | 18335 | 0.1% |
| 8 | 14547 | 0.1% |
| 9 | 11091 | 0.1% |
| Value | Count | Frequency (%) |
| 92 | 1 | |
| 90 | 1 | |
| 88 | 1 | |
| 85 | 2 | |
| 84 | 1 | |
| 83 | 1 | |
| 79 | 1 | |
| 78 | 1 | |
| 77 | 1 | |
| 76 | 1 |
cust_request_tn
Real number (ℝ)
High correlation  Skewed  Zeros 
| Distinct | 92002 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.071656524 |
| Minimum | 0 |
|---|---|
| Maximum | 551.56137 |
| Zeros | 14646469 |
| Zeros (%) | 86.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 129.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0.086 |
| Maximum | 551.56137 |
| Range | 551.56137 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.3397632 |
|---|---|
| Coefficient of variation (CV) | 18.697016 |
| Kurtosis | 17552.36 |
| Mean | 0.071656524 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 95.582294 |
| Sum | 1216633.2 |
| Variance | 1.7949654 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 14646469 | |
| 0.01638 | 14120 | 0.1% |
| 0.00218 | 12909 | 0.1% |
| 0.00983 | 11954 | 0.1% |
| 0.01092 | 10709 | 0.1% |
| 0.00546 | 10651 | 0.1% |
| 0.04095 | 10583 | 0.1% |
| 0.03276 | 10390 | 0.1% |
| 0.00109 | 10240 | 0.1% |
| 0.00491 | 10189 | 0.1% |
| Other values (91992) | 2230466 | 13.1% |
| Value | Count | Frequency (%) |
| 0 | 14646469 | |
| 0.0001 | 170 | < 0.1% |
| 0.00013 | 79 | < 0.1% |
| 0.00018 | 159 | < 0.1% |
| 0.0002 | 238 | < 0.1% |
| 0.00021 | 628 | < 0.1% |
| 0.00023 | 744 | < 0.1% |
| 0.00025 | 299 | < 0.1% |
| 0.00026 | 217 | < 0.1% |
| 0.00029 | 137 | < 0.1% |
| Value | Count | Frequency (%) |
| 551.56137 | 1 | |
| 510.65893 | 1 | |
| 444.41192 | 1 | |
| 439.90647 | 1 | |
| 437.37767 | 1 | |
| 416.64823 | 1 | |
| 407.02225 | 1 | |
| 393.26092 | 1 | |
| 389.02653 | 1 | |
| 384.82574 | 1 |
tn
Real number (ℝ)
High correlation  Skewed  Zeros 
| Distinct | 91943 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.070047949 |
| Minimum | 0 |
|---|---|
| Maximum | 547.87849 |
| Zeros | 14646469 |
| Zeros (%) | 86.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 129.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0.0859 |
| Maximum | 547.87849 |
| Range | 547.87849 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.2914311 |
|---|---|
| Coefficient of variation (CV) | 18.436387 |
| Kurtosis | 17961.662 |
| Mean | 0.070047949 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 96.082832 |
| Sum | 1189321.7 |
| Variance | 1.6677942 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 14646469 | |
| 0.01638 | 14125 | 0.1% |
| 0.00218 | 12908 | 0.1% |
| 0.00983 | 11954 | 0.1% |
| 0.01092 | 10714 | 0.1% |
| 0.00546 | 10653 | 0.1% |
| 0.04095 | 10583 | 0.1% |
| 0.03276 | 10404 | 0.1% |
| 0.00109 | 10242 | 0.1% |
| 0.00491 | 10188 | 0.1% |
| Other values (91933) | 2230440 | 13.1% |
| Value | Count | Frequency (%) |
| 0 | 14646469 | |
| 0.0001 | 170 | < 0.1% |
| 0.00013 | 79 | < 0.1% |
| 0.00018 | 159 | < 0.1% |
| 0.0002 | 238 | < 0.1% |
| 0.00021 | 628 | < 0.1% |
| 0.00023 | 746 | < 0.1% |
| 0.00025 | 299 | < 0.1% |
| 0.00026 | 217 | < 0.1% |
| 0.00029 | 137 | < 0.1% |
| Value | Count | Frequency (%) |
| 547.87849 | 1 | |
| 469.45761 | 1 | |
| 439.90647 | 1 | |
| 437.37767 | 1 | |
| 430.90803 | 1 | |
| 414.05146 | 1 | |
| 389.02653 | 1 | |
| 386.60688 | 1 | |
| 384.82574 | 1 | |
| 379.4427 | 1 |
stock_final
Real number (ℝ)
Zeros 
| Distinct | 10047 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.3507683 |
| Minimum | -13.66656 |
|---|---|
| Maximum | 1562.0245 |
| Zeros | 10719135 |
| Zeros (%) | 63.1% |
| Negative | 159399 |
| Negative (%) | 0.9% |
| Memory size | 129.5 MiB |
Quantile statistics
| Minimum | -13.66656 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 2.828945 |
| 95-th percentile | 38.085946 |
| Maximum | 1562.0245 |
| Range | 1575.691 |
| Interquartile range (IQR) | 2.828945 |
Descriptive statistics
| Standard deviation | 39.37932 |
|---|---|
| Coefficient of variation (CV) | 4.7156523 |
| Kurtosis | 373.86696 |
| Mean | 8.3507683 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 15.862276 |
| Sum | 1.4178502 × 108 |
| Variance | 1550.7309 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 10719135 | |
| 0.00109 | 2388 | < 0.1% |
| -0.01747 | 2388 | < 0.1% |
| 0.04423 | 2388 | < 0.1% |
| 36.58637 | 2388 | < 0.1% |
| 3.42342 | 2388 | < 0.1% |
| 0.0819 | 2388 | < 0.1% |
| 0.7204 | 2388 | < 0.1% |
| 0.049 | 2388 | < 0.1% |
| 0.02092 | 2388 | < 0.1% |
| Other values (10037) | 6238053 |
| Value | Count | Frequency (%) |
| -13.66656 | 597 | |
| -13.33127 | 597 | |
| -8.19961 | 597 | |
| -8.15986 | 597 | |
| -7.7212 | 597 | |
| -5.86579 | 597 | |
| -5.28091 | 597 | |
| -5.0992 | 597 | |
| -4.87775 | 597 | |
| -4.44673 | 597 |
| Value | Count | Frequency (%) |
| 1562.02448 | 597 | |
| 1284.38214 | 597 | |
| 1212.36734 | 597 | |
| 1146.09799 | 597 | |
| 1097.55623 | 597 | |
| 1057.38804 | 597 | |
| 1037.85386 | 597 | |
| 1031.01561 | 597 | |
| 978.16446 | 597 | |
| 916.3419 | 597 |
cat1
Categorical
High correlation 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 835.0 MiB |
| PC | |
|---|---|
| HC | |
| FOODS | |
| REF | 128952 |
Length
| Max length | 5 |
|---|---|
| Median length | 2 |
| Mean length | 2.5658228 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | HC |
|---|---|
| 2nd row | HC |
| 3rd row | HC |
| 4th row | HC |
| 5th row | HC |
Common Values
| Value | Count | Frequency (%) |
| PC | 9585432 | |
| HC | 4104972 | |
| FOODS | 3159324 | 18.6% |
| REF | 128952 | 0.8% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| pc | 9585432 | |
| hc | 4104972 | |
| foods | 3159324 | 18.6% |
| ref | 128952 | 0.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 13690404 | |
| P | 9585432 | |
| O | 6318648 | |
| H | 4104972 | 9.4% |
| F | 3288276 | 7.5% |
| D | 3159324 | 7.3% |
| S | 3159324 | 7.3% |
| R | 128952 | 0.3% |
| E | 128952 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 43564284 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 13690404 | |
| P | 9585432 | |
| O | 6318648 | |
| H | 4104972 | 9.4% |
| F | 3288276 | 7.5% |
| D | 3159324 | 7.3% |
| S | 3159324 | 7.3% |
| R | 128952 | 0.3% |
| E | 128952 | 0.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 43564284 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| C | 13690404 | |
| P | 9585432 | |
| O | 6318648 | |
| H | 4104972 | 9.4% |
| F | 3288276 | 7.5% |
| D | 3159324 | 7.3% |
| S | 3159324 | 7.3% |
| R | 128952 | 0.3% |
| E | 128952 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 43564284 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| C | 13690404 | |
| P | 9585432 | |
| O | 6318648 | |
| H | 4104972 | 9.4% |
| F | 3288276 | 7.5% |
| D | 3159324 | 7.3% |
| S | 3159324 | 7.3% |
| R | 128952 | 0.3% |
| E | 128952 | 0.3% |
cat2
Categorical
High correlation 
| Distinct | 15 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 916.0 MiB |
| CABELLO | |
|---|---|
| DEOS | |
| SOPAS Y CALDOS | |
| HOGAR | |
| ROPA LAVADO | |
| Other values (10) |
Length
| Max length | 19 |
|---|---|
| Median length | 14 |
| Mean length | 7.5708861 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ROPA LAVADO |
|---|---|
| 2nd row | ROPA LAVADO |
| 3rd row | ROPA LAVADO |
| 4th row | ROPA LAVADO |
| 5th row | ROPA LAVADO |
Common Values
| Value | Count | Frequency (%) |
| CABELLO | 4405860 | |
| DEOS | 2643516 | |
| SOPAS Y CALDOS | 1891296 | |
| HOGAR | 1353996 | 8.0% |
| ROPA LAVADO | 1225044 | 7.2% |
| PIEL2 | 1225044 | 7.2% |
| ADEREZOS | 1074600 | 6.3% |
| PIEL1 | 1010124 | 5.9% |
| VAJILLA | 709236 | 4.2% |
| ROPA ACONDICIONADOR | 451332 | 2.7% |
| Other values (5) | 988632 | 5.8% |
Length
| Value | Count | Frequency (%) |
| cabello | 4405860 | |
| deos | 2643516 | |
| sopas | 1891296 | |
| y | 1891296 | |
| caldos | 1891296 | |
| ropa | 1719360 | 7.6% |
| hogar | 1353996 | 6.0% |
| lavado | 1225044 | 5.4% |
| piel2 | 1225044 | 5.4% |
| aderezos | 1074600 | 4.8% |
| Other values (8) | 3159324 |
Most occurring characters
| Value | Count | Frequency (%) |
| O | 18590580 | |
| A | 17816868 | |
| L | 16204968 | |
| E | 12185964 | |
| S | 9950796 | |
| D | 8038008 | 6.3% |
| C | 7242804 | 5.6% |
| P | 6168204 | 4.8% |
| 5501952 | 4.3% | |
| R | 5115096 | 4.0% |
| Other values (14) | 21728412 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 120806532 | |
| Space Separator | 5501952 | 4.3% |
| Decimal Number | 2235168 | 1.7% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 18590580 | |
| A | 17816868 | |
| L | 16204968 | |
| E | 12185964 | |
| S | 9950796 | |
| D | 8038008 | |
| C | 7242804 | 6.0% |
| P | 6168204 | 5.1% |
| R | 5115096 | 4.2% |
| B | 4405860 | 3.6% |
| Other values (11) | 15087384 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 1225044 | |
| 1 | 1010124 |
Space Separator
| Value | Count | Frequency (%) |
| 5501952 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 120806532 | |
| Common | 7737120 | 6.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| O | 18590580 | |
| A | 17816868 | |
| L | 16204968 | |
| E | 12185964 | |
| S | 9950796 | |
| D | 8038008 | |
| C | 7242804 | 6.0% |
| P | 6168204 | 5.1% |
| R | 5115096 | 4.2% |
| B | 4405860 | 3.6% |
| Other values (11) | 15087384 |
Common
| Value | Count | Frequency (%) |
| 5501952 | ||
| 2 | 1225044 | 15.8% |
| 1 | 1010124 | 13.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 128543652 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| O | 18590580 | |
| A | 17816868 | |
| L | 16204968 | |
| E | 12185964 | |
| S | 9950796 | |
| D | 8038008 | 6.3% |
| C | 7242804 | 5.6% |
| P | 6168204 | 4.8% |
| 5501952 | 4.3% | |
| R | 5115096 | 4.0% |
| Other values (14) | 21728412 |
cat3
Text
| Distinct | 84 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 930.3 MiB |
Length
| Max length | 19 |
|---|---|
| Median length | 16 |
| Mean length | 7.9481013 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Liquido |
|---|---|
| 2nd row | Liquido |
| 3rd row | Liquido |
| 4th row | Liquido |
| 5th row | Liquido |
| Value | Count | Frequency (%) |
| shampoo | 1998756 | 10.0% |
| aero | 1676376 | 8.4% |
| acondicionador | 1654884 | 8.3% |
| jabon | 816696 | 4.1% |
| liquido | 730728 | 3.6% |
| sopas | 687744 | 3.4% |
| polvo | 623268 | 3.1% |
| mayonesa | 558792 | 2.8% |
| noaero | 494316 | 2.5% |
| gel | 472824 | 2.4% |
| Other values (80) | 10316160 |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 11820600 | 8.8% |
| O | 10187208 | 7.5% |
| a | 9628416 | 7.1% |
| A | 9370512 | 6.9% |
| e | 6769980 | 5.0% |
| C | 6189696 | 4.6% |
| r | 5931792 | 4.4% |
| S | 4577796 | 3.4% |
| i | 4470336 | 3.3% |
| I | 4448844 | 3.3% |
| Other values (41) | 61553088 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 68473512 | |
| Uppercase Letter | 63422892 | |
| Space Separator | 3051864 | 2.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 11820600 | |
| a | 9628416 | |
| e | 6769980 | |
| r | 5931792 | |
| i | 4470336 | 6.5% |
| l | 4384368 | 6.4% |
| s | 3825576 | 5.6% |
| n | 3782592 | 5.5% |
| u | 2557548 | 3.7% |
| d | 2428596 | 3.5% |
| Other values (15) | 12873708 |
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 10187208 | |
| A | 9370512 | |
| C | 6189696 | |
| S | 4577796 | |
| I | 4448844 | |
| N | 4233924 | |
| D | 3976020 | 6.3% |
| P | 3589164 | 5.7% |
| M | 3567672 | 5.6% |
| R | 2879928 | 4.5% |
| Other values (15) | 10402128 |
Space Separator
| Value | Count | Frequency (%) |
| 3051864 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 131896404 | |
| Common | 3051864 | 2.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 11820600 | 9.0% |
| O | 10187208 | 7.7% |
| a | 9628416 | 7.3% |
| A | 9370512 | 7.1% |
| e | 6769980 | 5.1% |
| C | 6189696 | 4.7% |
| r | 5931792 | 4.5% |
| S | 4577796 | 3.5% |
| i | 4470336 | 3.4% |
| I | 4448844 | 3.4% |
| Other values (40) | 58501224 |
Common
| Value | Count | Frequency (%) |
| 3051864 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 134561412 | |
| None | 386856 | 0.3% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 11820600 | 8.8% |
| O | 10187208 | 7.6% |
| a | 9628416 | 7.2% |
| A | 9370512 | 7.0% |
| e | 6769980 | 5.0% |
| C | 6189696 | 4.6% |
| r | 5931792 | 4.4% |
| S | 4577796 | 3.4% |
| i | 4470336 | 3.3% |
| I | 4448844 | 3.3% |
| Other values (40) | 61166232 |
None
| Value | Count | Frequency (%) |
| ñ | 386856 |
brand
Categorical
High correlation 
| Distinct | 35 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 895.6 MiB |
| NIVEA | |
|---|---|
| SHAMPOO3 | |
| MAGGI | |
| DEOS1 | |
| MUSCULO | |
| Other values (30) |
Length
| Max length | 9 |
|---|---|
| Median length | 8 |
| Mean length | 6.3088608 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ARIEL |
|---|---|
| 2nd row | ARIEL |
| 3rd row | ARIEL |
| 4th row | ARIEL |
| 5th row | ARIEL |
Common Values
| Value | Count | Frequency (%) |
| NIVEA | 2342628 | |
| SHAMPOO3 | 1805328 | 10.6% |
| MAGGI | 1740852 | 10.3% |
| DEOS1 | 1676376 | 9.9% |
| MUSCULO | 1396980 | 8.2% |
| LIMPIEX | 1053108 | 6.2% |
| LANCOME | 644760 | 3.8% |
| SHAMPOO2 | 623268 | 3.7% |
| NATURA | 601776 | 3.5% |
| SHAMPOO1 | 580284 | 3.4% |
| Other values (25) | 4513320 |
Length
| Value | Count | Frequency (%) |
| nivea | 2342628 | |
| shampoo3 | 1805328 | 10.6% |
| maggi | 1740852 | 10.3% |
| deos1 | 1676376 | 9.9% |
| musculo | 1396980 | 8.2% |
| limpiex | 1053108 | 6.2% |
| lancome | 644760 | 3.8% |
| shampoo2 | 623268 | 3.7% |
| natura | 601776 | 3.5% |
| shampoo1 | 580284 | 3.4% |
| Other values (25) | 4513320 |
Most occurring characters
| Value | Count | Frequency (%) |
| O | 12207456 | 11.4% |
| A | 12164472 | 11.4% |
| M | 8682768 | 8.1% |
| I | 8532324 | 8.0% |
| E | 8209944 | 7.7% |
| S | 7629660 | 7.1% |
| N | 4921668 | 4.6% |
| P | 4835700 | 4.5% |
| L | 4577796 | 4.3% |
| G | 4190940 | 3.9% |
| Other values (25) | 31163400 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 100195704 | |
| Decimal Number | 6060744 | 5.7% |
| Lowercase Letter | 859680 | 0.8% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 12207456 | |
| A | 12164472 | |
| M | 8682768 | 8.7% |
| I | 8532324 | 8.5% |
| E | 8209944 | 8.2% |
| S | 7629660 | 7.6% |
| N | 4921668 | 4.9% |
| P | 4835700 | 4.8% |
| L | 4577796 | 4.6% |
| G | 4190940 | 4.2% |
| Other values (15) | 24242976 |
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 214920 | |
| m | 107460 | |
| p | 107460 | |
| r | 107460 | |
| t | 107460 | |
| a | 107460 | |
| d | 107460 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 2944404 | |
| 3 | 2127708 | |
| 2 | 988632 | 16.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 101055384 | |
| Common | 6060744 | 5.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| O | 12207456 | |
| A | 12164472 | |
| M | 8682768 | 8.6% |
| I | 8532324 | 8.4% |
| E | 8209944 | 8.1% |
| S | 7629660 | 7.5% |
| N | 4921668 | 4.9% |
| P | 4835700 | 4.8% |
| L | 4577796 | 4.5% |
| G | 4190940 | 4.1% |
| Other values (22) | 25102656 |
Common
| Value | Count | Frequency (%) |
| 1 | 2944404 | |
| 3 | 2127708 | |
| 2 | 988632 | 16.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 107116128 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| O | 12207456 | 11.4% |
| A | 12164472 | 11.4% |
| M | 8682768 | 8.1% |
| I | 8532324 | 8.0% |
| E | 8209944 | 7.7% |
| S | 7629660 | 7.1% |
| N | 4921668 | 4.6% |
| P | 4835700 | 4.5% |
| L | 4577796 | 4.3% |
| G | 4190940 | 3.9% |
| Other values (25) | 31163400 |
sku_size
Real number (ℝ)
High correlation 
| Distinct | 67 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 459.64937 |
| Minimum | 1 |
|---|---|
| Maximum | 10000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 129.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 90 |
| median | 220 |
| Q3 | 450 |
| 95-th percentile | 1000 |
| Maximum | 10000 |
| Range | 9999 |
| Interquartile range (IQR) | 360 |
Descriptive statistics
| Standard deviation | 895.1031 |
|---|---|
| Coefficient of variation (CV) | 1.9473607 |
| Kurtosis | 40.891263 |
| Mean | 459.64937 |
| Median Absolute Deviation (MAD) | 170 |
| Skewness | 5.5270969 |
| Sum | 7.8042395 × 109 |
| Variance | 801209.55 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 200 | 1289520 | 7.6% |
| 400 | 1203552 | 7.1% |
| 50 | 1031616 | 6.1% |
| 90 | 988632 | 5.8% |
| 350 | 795204 | 4.7% |
| 10 | 687744 | 4.1% |
| 750 | 666252 | 3.9% |
| 500 | 601776 | 3.5% |
| 100 | 601776 | 3.5% |
| 250 | 537300 | 3.2% |
| Other values (57) | 8575308 |
| Value | Count | Frequency (%) |
| 1 | 171936 | 1.0% |
| 2 | 214920 | 1.3% |
| 3 | 21492 | 0.1% |
| 4 | 171936 | 1.0% |
| 5 | 322380 | |
| 6 | 85968 | 0.5% |
| 8 | 128952 | 0.8% |
| 10 | 687744 | |
| 12 | 171936 | 1.0% |
| 15 | 150444 | 0.9% |
| Value | Count | Frequency (%) |
| 10000 | 42984 | 0.3% |
| 5000 | 236412 | |
| 4000 | 21492 | 0.1% |
| 3000 | 429840 | |
| 2000 | 42984 | 0.3% |
| 1400 | 42984 | 0.3% |
| 1250 | 21492 | 0.1% |
| 1000 | 279396 | |
| 950 | 64476 | 0.4% |
| 930 | 300888 |
Interactions
Correlations
| brand | cat1 | cat2 | cust_request_qty | cust_request_tn | customer_id | periodo | plan_precios_cuidados | product_id | sku_size | stock_final | tn | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| brand | 1.000 | 0.999 | 0.825 | 0.008 | 0.008 | 0.000 | 0.000 | 0.081 | 0.374 | 0.272 | 0.073 | 0.008 |
| cat1 | 0.999 | 1.000 | 1.000 | 0.007 | 0.008 | 0.000 | 0.000 | 0.015 | 0.312 | 0.233 | 0.064 | 0.007 |
| cat2 | 0.825 | 1.000 | 1.000 | 0.007 | 0.007 | 0.000 | 0.000 | 0.051 | 0.284 | 0.454 | 0.063 | 0.007 |
| cust_request_qty | 0.008 | 0.007 | 0.007 | 1.000 | 0.996 | -0.302 | 0.005 | 0.021 | -0.170 | 0.007 | 0.038 | 0.996 |
| cust_request_tn | 0.008 | 0.008 | 0.007 | 0.996 | 1.000 | -0.306 | 0.001 | 0.001 | -0.187 | 0.021 | 0.040 | 1.000 |
| customer_id | 0.000 | 0.000 | 0.000 | -0.302 | -0.306 | 1.000 | 0.000 | 0.031 | 0.000 | 0.000 | -0.000 | -0.306 |
| periodo | 0.000 | 0.000 | 0.000 | 0.005 | 0.001 | 0.000 | 1.000 | 0.021 | 0.000 | 0.000 | 0.050 | 0.001 |
| plan_precios_cuidados | 0.081 | 0.015 | 0.051 | 0.021 | 0.001 | 0.031 | 0.021 | 1.000 | 0.033 | 0.007 | 0.002 | 0.001 |
| product_id | 0.374 | 0.312 | 0.284 | -0.170 | -0.187 | 0.000 | 0.000 | 0.033 | 1.000 | -0.518 | -0.120 | -0.187 |
| sku_size | 0.272 | 0.233 | 0.454 | 0.007 | 0.021 | 0.000 | 0.000 | 0.007 | -0.518 | 1.000 | 0.067 | 0.021 |
| stock_final | 0.073 | 0.064 | 0.063 | 0.038 | 0.040 | -0.000 | 0.050 | 0.002 | -0.120 | 0.067 | 1.000 | 0.040 |
| tn | 0.008 | 0.007 | 0.007 | 0.996 | 1.000 | -0.306 | 0.001 | 0.001 | -0.187 | 0.021 | 0.040 | 1.000 |
Missing values
Sample
| customer_id | product_id | periodo | plan_precios_cuidados | cust_request_qty | cust_request_tn | tn | stock_final | cat1 | cat2 | cat3 | brand | sku_size | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 10001 | 20001 | 2017-01-01 | 0.0 | 11.0 | 99.43861 | 99.43861 | 0.0 | HC | ROPA LAVADO | Liquido | ARIEL | 3000 |
| 1 | 10001 | 20001 | 2017-02-01 | 0.0 | 23.0 | 198.84365 | 198.84365 | 0.0 | HC | ROPA LAVADO | Liquido | ARIEL | 3000 |
| 2 | 10001 | 20001 | 2017-03-01 | 0.0 | 33.0 | 92.46537 | 92.46537 | 0.0 | HC | ROPA LAVADO | Liquido | ARIEL | 3000 |
| 3 | 10001 | 20001 | 2017-04-01 | 0.0 | 8.0 | 13.29728 | 13.29728 | 0.0 | HC | ROPA LAVADO | Liquido | ARIEL | 3000 |
| 4 | 10001 | 20001 | 2017-05-01 | 0.0 | 15.0 | 101.20711 | 101.00563 | 0.0 | HC | ROPA LAVADO | Liquido | ARIEL | 3000 |
| 5 | 10001 | 20001 | 2017-06-01 | 0.0 | 25.0 | 128.04792 | 128.04792 | 0.0 | HC | ROPA LAVADO | Liquido | ARIEL | 3000 |
| 6 | 10001 | 20001 | 2017-07-01 | 0.0 | 18.0 | 101.20711 | 101.20711 | 0.0 | HC | ROPA LAVADO | Liquido | ARIEL | 3000 |
| 7 | 10001 | 20001 | 2017-08-01 | 0.0 | 17.0 | 43.33930 | 43.33930 | 0.0 | HC | ROPA LAVADO | Liquido | ARIEL | 3000 |
| 8 | 10001 | 20001 | 2017-09-01 | 0.0 | 36.0 | 289.35024 | 289.35024 | 0.0 | HC | ROPA LAVADO | Liquido | ARIEL | 3000 |
| 9 | 10001 | 20001 | 2017-10-01 | 0.0 | 22.0 | 222.11389 | 222.11389 | 0.0 | HC | ROPA LAVADO | Liquido | ARIEL | 3000 |
| customer_id | product_id | periodo | plan_precios_cuidados | cust_request_qty | cust_request_tn | tn | stock_final | cat1 | cat2 | cat3 | brand | sku_size | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16978670 | 10637 | 21276 | 2019-03-01 | 0.0 | 0.0 | 0.0 | 0.0 | 1.68932 | PC | PIEL1 | Cara | NIVEA | 140 |
| 16978671 | 10637 | 21276 | 2019-04-01 | 0.0 | 0.0 | 0.0 | 0.0 | 1.57051 | PC | PIEL1 | Cara | NIVEA | 140 |
| 16978672 | 10637 | 21276 | 2019-05-01 | 0.0 | 0.0 | 0.0 | 0.0 | 1.30988 | PC | PIEL1 | Cara | NIVEA | 140 |
| 16978673 | 10637 | 21276 | 2019-06-01 | 0.0 | 0.0 | 0.0 | 0.0 | 1.29354 | PC | PIEL1 | Cara | NIVEA | 140 |
| 16978674 | 10637 | 21276 | 2019-07-01 | 0.0 | 0.0 | 0.0 | 0.0 | 1.28908 | PC | PIEL1 | Cara | NIVEA | 140 |
| 16978675 | 10637 | 21276 | 2019-08-01 | 0.0 | 0.0 | 0.0 | 0.0 | 1.08488 | PC | PIEL1 | Cara | NIVEA | 140 |
| 16978676 | 10637 | 21276 | 2019-09-01 | 0.0 | 0.0 | 0.0 | 0.0 | 0.87622 | PC | PIEL1 | Cara | NIVEA | 140 |
| 16978677 | 10637 | 21276 | 2019-10-01 | 0.0 | 0.0 | 0.0 | 0.0 | 1.05889 | PC | PIEL1 | Cara | NIVEA | 140 |
| 16978678 | 10637 | 21276 | 2019-11-01 | 0.0 | 0.0 | 0.0 | 0.0 | 1.06112 | PC | PIEL1 | Cara | NIVEA | 140 |
| 16978679 | 10637 | 21276 | 2019-12-01 | 0.0 | 0.0 | 0.0 | 0.0 | 1.05592 | PC | PIEL1 | Cara | NIVEA | 140 |
Duplicate rows
Most frequently occurring
| customer_id | product_id | periodo | plan_precios_cuidados | cust_request_qty | cust_request_tn | tn | stock_final | cat1 | cat2 | cat3 | brand | sku_size | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 10001 | 20010 | 2017-01-01 | 0.0 | 3.0 | 1.31914 | 1.31914 | 0.0 | HC | ROPA LAVADO | Polvo | LIMPIEX | 400 | 2 |
| 1 | 10001 | 20010 | 2017-02-01 | 0.0 | 1.0 | 0.11357 | 0.11357 | 0.0 | HC | ROPA LAVADO | Polvo | LIMPIEX | 400 | 2 |
| 2 | 10001 | 20010 | 2017-03-01 | 0.0 | 0.0 | 0.00000 | 0.00000 | 0.0 | HC | ROPA LAVADO | Polvo | LIMPIEX | 400 | 2 |
| 3 | 10001 | 20010 | 2017-04-01 | 0.0 | 0.0 | 0.00000 | 0.00000 | 0.0 | HC | ROPA LAVADO | Polvo | LIMPIEX | 400 | 2 |
| 4 | 10001 | 20010 | 2017-05-01 | 0.0 | 0.0 | 0.00000 | 0.00000 | 0.0 | HC | ROPA LAVADO | Polvo | LIMPIEX | 400 | 2 |
| 5 | 10001 | 20010 | 2017-06-01 | 0.0 | 0.0 | 0.00000 | 0.00000 | 0.0 | HC | ROPA LAVADO | Polvo | LIMPIEX | 400 | 2 |
| 6 | 10001 | 20010 | 2017-07-01 | 0.0 | 0.0 | 0.00000 | 0.00000 | 0.0 | HC | ROPA LAVADO | Polvo | LIMPIEX | 400 | 2 |
| 7 | 10001 | 20010 | 2017-08-01 | 0.0 | 0.0 | 0.00000 | 0.00000 | 0.0 | HC | ROPA LAVADO | Polvo | LIMPIEX | 400 | 2 |
| 8 | 10001 | 20010 | 2017-09-01 | 0.0 | 0.0 | 0.00000 | 0.00000 | 0.0 | HC | ROPA LAVADO | Polvo | LIMPIEX | 400 | 2 |
| 9 | 10001 | 20010 | 2017-10-01 | 0.0 | 0.0 | 0.00000 | 0.00000 | 0.0 | HC | ROPA LAVADO | Polvo | LIMPIEX | 400 | 2 |